|
500
|
How can I filter items for dates before a specified date
axTree1.BeginUpdate();
EXTREELib.Column var_Column = (axTree1.Columns.Add("Dates") as EXTREELib.Column);
var_Column.SortType = EXTREELib.SortTypeEnum.SortDate;
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.DisplayFilterDate = true;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowFocusItem | EXTREELib.FilterListEnum.exNoItems;
var_Column.Filter = "to 12/27/2010";
var_Column.FilterType = EXTREELib.FilterTypeEnum.exDate;
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("12/27/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/28/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/29/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/30/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/31/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
axTree1.ApplyFilter();
axTree1.EndUpdate();
|
|
499
|
Is it possible to filter dates
axTree1.BeginUpdate();
EXTREELib.Column var_Column = (axTree1.Columns.Add("Dates") as EXTREELib.Column);
var_Column.SortType = EXTREELib.SortTypeEnum.SortDate;
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.DisplayFilterDate = true;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowFocusItem | EXTREELib.FilterListEnum.exNoItems;
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("12/27/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/28/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/29/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/30/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("12/31/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
axTree1.EndUpdate();
|
|
498
|
Is it possible to change the Exclude field name to something different, in the drop down filter window
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.set_Description(EXTREELib.DescriptionTypeEnum.exFilterBarExclude,"Leaving out");
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowExclude | EXTREELib.FilterListEnum.exShowFocusItem | EXTREELib.FilterListEnum.exShowCheckBox;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
axTree1.EndUpdate();
|
|
497
|
How can I display the Exclude field in the drop down filter window
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowExclude | EXTREELib.FilterListEnum.exShowFocusItem | EXTREELib.FilterListEnum.exShowCheckBox;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
axTree1.EndUpdate();
|
|
496
|
Is it possible to show and ensure the focused item from the control, in the drop down filter window
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowFocusItem | EXTREELib.FilterListEnum.exShowCheckBox;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.set_SelectItem(var_Items.InsertItem(h,null,"Child 2"),true);
var_Items.set_ExpandItem(h,true);
axTree1.EndUpdate();
|
|
495
|
Is it possible to show only blanks items with no listed items from the control
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowBlanks | EXTREELib.FilterListEnum.exNoItems;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.EndUpdate();
|
|
494
|
How can I include the blanks items in the drop down filter window
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowBlanks | EXTREELib.FilterListEnum.exShowCheckBox;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.EndUpdate();
|
|
493
|
How can I select multiple items in the drop down filter window, using check-boxes
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exShowCheckBox;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.EndUpdate();
|
|
492
|
Is it possible to allow a single item being selected in the drop down filter window
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.FilterList = EXTREELib.FilterListEnum.exSingleSel;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.EndUpdate();
|
|
491
|
How can I display no (All) item in the drop down filter window
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.set_Description(EXTREELib.DescriptionTypeEnum.exFilterBarAll,"");
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.FilterList = EXTREELib.FilterListEnum.exNoItems;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.EndUpdate();
|
|
490
|
Is it possible to display no items in the drop down filter window, so only the pattern is visible
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Items") as EXTREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.FilterList = EXTREELib.FilterListEnum.exNoItems;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.EndUpdate();
|
|
489
|
How do I hide the selection
axTree1.BeginUpdate();
axTree1.MarkSearchColumn = false;
axTree1.SelForeColor = axTree1.ForeColor;
axTree1.SelBackColor = axTree1.BackColor;
axTree1.ShowFocusRect = false;
EXTREELib.Columns var_Columns = axTree1.Columns;
EXTREELib.Column var_Column = (var_Columns.Add("Format") as EXTREELib.Column);
var_Column.FormatColumn = "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=00" +
"00FF>+'+(value format '2|.|3|,' ): '0.00') )";
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(10);
var_Items.AddItem(-8);
axTree1.EndUpdate();
|
|
488
|
How do I access the cells, or how do I get the values in the columns
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("C1");
var_Columns.Add("C2");
var_Columns.Add("C3");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Item 1");
var_Items.set_CellCaption(h,1,"SubItem 1.1");
var_Items.set_CellCaption(h,2,"SubItem 1.2");
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(h,0).ToString() );
|
|
487
|
Is it possible to load child items when clicking the +/- button
// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
private void axTree1_BeforeExpandItem(object sender, AxEXTREELib._ITreeEvents_BeforeExpandItemEvent e)
{
EXTREELib.Items var_Items = axTree1.Items;
var_Items.InsertItem(e.item,null,"new");
var_Items.set_ItemHasChildren(var_Items.InsertItem(e.item,null,"new"),true);
var_Items.InsertItem(e.item,null,"new");
}
//this.axTree1.BeforeExpandItem += new AxEXTREELib._ITreeEvents_BeforeExpandItemEventHandler(this.axTree1_BeforeExpandItem);
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_ItemHasChildren(var_Items.AddItem("aka"),true);
var_Items.AddItem("next item");
|
|
486
|
How can I change the check-boxes appearance
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("Default") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.PartialCheck = true;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
EXTREELib.Appearance var_Appearance = axTree1.VisualAppearance;
var_Appearance.Add(1,"XP:Button 3 12");
var_Appearance.Add(2,"XP:Button 3 11");
var_Appearance.Add(3,"XP:Button 3 10");
axTree1.set_CheckImage(EXTREELib.CheckStateEnum.Unchecked,16777216);
axTree1.set_CheckImage(EXTREELib.CheckStateEnum.Checked,33554432);
axTree1.set_CheckImage(EXTREELib.CheckStateEnum.PartialChecked,50331648);
|
|
485
|
How can I initiate the OLE Drag and Drop support
// OLEStartDrag event - Occurs when the OLEDrag method is called.
private void axTree1_OLEStartDrag(object sender, AxEXTREELib._ITreeEvents_OLEStartDragEvent e)
{
// Data.SetData("data to drag")
e.allowedEffects = 1;
}
//this.axTree1.OLEStartDrag += new AxEXTREELib._ITreeEvents_OLEStartDragEventHandler(this.axTree1_OLEStartDrag);
axTree1.OLEDropMode = EXTREELib.exOLEDropModeEnum.exOLEDropManual;
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
|
|
484
|
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
axTree1.BeginUpdate();
EXTREELib.ConditionalFormat var_ConditionalFormat = axTree1.ConditionalFormats.Add("1","K1");
var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
var_ConditionalFormat.ApplyTo = (EXTREELib.FormatApplyToEnum)0x1;
EXTREELib.ConditionalFormat var_ConditionalFormat1 = axTree1.ConditionalFormats.Add("1","K2");
var_ConditionalFormat1.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
var_ConditionalFormat1.ApplyTo = (EXTREELib.FormatApplyToEnum)0x2;
axTree1.MarkSearchColumn = false;
axTree1.DrawGridLines = EXTREELib.GridLinesEnum.exRowLines;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
var_Columns.Add("Column 3");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(null);
var_Items.AddItem(null);
var_Items.AddItem(null);
axTree1.EndUpdate();
|
|
483
|
Is it possible to display empty strings for 0 values
(axTree1.Columns.Add("Currency") as EXTREELib.Column).FormatColumn = "dbl(value) ? currency(dbl(value)) : ``";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(1.23);
var_Items.AddItem(2.34);
var_Items.AddItem(0);
var_Items.AddItem(10000.99);
|
|
482
|
Is it possible to display empty strings for 0 values
axTree1.Columns.Add("Number");
(axTree1.Columns.Add("Currency") as EXTREELib.Column).ComputedField = "%0 ? currency(%0) : ``";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(1.23);
var_Items.AddItem(2.34);
var_Items.AddItem(0);
var_Items.AddItem(10000.99);
|
|
481
|
How can I get the list of items as they are displayed
axTree1.BeginUpdate();
axTree1.BackColorAlternate = Color.FromArgb(240,240,240);
axTree1.Columns.Add("Names");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
axTree1.Columns[0].SortOrder = EXTREELib.SortOrderEnum.SortAscending;
axTree1.EndUpdate();
System.Diagnostics.Debug.Print( axTree1.GetItems(1).ToString() );
|
|
480
|
Is posible to reduce the size of the picture to be shown in the column's caption
axTree1.BeginUpdate();
axTree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
axTree1.HeaderHeight = 48;
(axTree1.Columns.Add("DefaultSize") as EXTREELib.Column).HTMLCaption = "Default-Size <img>pic1</img> Picture";
(axTree1.Columns.Add("CustomSize") as EXTREELib.Column).HTMLCaption = "Custom-Size <img>pic1:16</img> Picture";
axTree1.EndUpdate();
|
|
479
|
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
axTree1.BeginUpdate();
axTree1.MarkSearchColumn = false;
EXTREELib.ConditionalFormat var_ConditionalFormat = axTree1.ConditionalFormats.Add("1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
var_ConditionalFormat.ApplyTo = (EXTREELib.FormatApplyToEnum)0x1;
axTree1.Columns.Add("C1");
EXTREELib.Column var_Column = (axTree1.Columns.Add("C2") as EXTREELib.Column);
var_Column.HeaderBold = true;
var_Column.HTMLCaption = "<fgcolor=FF0000>C2";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(10),1,11);
var_Items.set_CellCaption(var_Items.AddItem(12),1,13);
axTree1.EndUpdate();
|
|
478
|
The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state has been changed.
private void axTree1_CellStateChanged(object sender, AxEXTREELib._ITreeEvents_CellStateChangedEvent e)
{
axTree1.Items.set_SelectItem(e.item,true);
}
//this.axTree1.CellStateChanged += new AxEXTREELib._ITreeEvents_CellStateChangedEventHandler(this.axTree1_CellStateChanged);
(axTree1.Columns.Add("Check") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
var_Items.AddItem(3);
|
|
477
|
Is it possible to limit the height of the item while resizing
// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axTree1_AddItem(object sender, AxEXTREELib._ITreeEvents_AddItemEvent e)
{
axTree1.Items.set_ItemMinHeight(e.item,18);
axTree1.Items.set_ItemMaxHeight(e.item,72);
}
//this.axTree1.AddItem += new AxEXTREELib._ITreeEvents_AddItemEventHandler(this.axTree1_AddItem);
axTree1.BeginUpdate();
axTree1.ItemsAllowSizing = EXTREELib.ItemsAllowSizingEnum.exResizeItem;
axTree1.ScrollBySingleLine = false;
axTree1.BackColorAlternate = Color.FromArgb(240,240,240);
axTree1.Columns.Add("Names");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
axTree1.Columns[0].SortOrder = EXTREELib.SortOrderEnum.SortAscending;
axTree1.EndUpdate();
|
|
476
|
Is it possible to copy the hierarchy of the control using the GetItems method
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Def");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
axTree1.PutItems(axTree1.GetItems(-1),null);
|
|
475
|
How can I show the child items with no identation
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exGroupLinesOutside;
axTree1.Indent = 12;
axTree1.HasLines = EXTREELib.HierarchyLineEnum.exThinLine;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
|
|
474
|
Is there other ways of showing the hierarchy lines (exGroupLinesAtRoot)
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot;
axTree1.Indent = 12;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
473
|
Is there other ways of showing the hierarchy lines (exGroupLinesOutside)
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exGroupLinesOutside;
axTree1.Indent = 12;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
|
|
472
|
Is there other ways of showing the hierarchy lines (exGroupLinesInsideLeaf)
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exGroupLinesInsideLeaf;
axTree1.Indent = 12;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
471
|
Is there other ways of showing the hierarchy lines (exGroupLinesInside)
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exGroupLinesInside;
axTree1.Indent = 12;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
470
|
Is there other ways of showing the hierarchy lines (exGroupLines)
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exGroupLines;
axTree1.Indent = 12;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(var_Items.InsertItem(h,null,"Child 2"),null,"SubChild 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
469
|
Does your control supports multiple lines tooltip
axTree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
axTree1.ToolTipDelay = 1;
(axTree1.Columns.Add("tootip") as EXTREELib.Column).ToolTip = "<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, " +
"icons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>";
|
|
468
|
How can I prevent highlighting the column from the cursor - point
axTree1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJ" +
"gEgI=");
axTree1.set_Background(EXTREELib.BackgroundPartEnum.exCursorHoverColumn,0x1000000);
(axTree1.Columns.Add("S") as EXTREELib.Column).Width = 32;
(axTree1.Columns.Add("Level 1") as EXTREELib.Column).LevelKey = 1;
(axTree1.Columns.Add("Level 2") as EXTREELib.Column).LevelKey = 1;
(axTree1.Columns.Add("Level 3") as EXTREELib.Column).LevelKey = 1;
(axTree1.Columns.Add("E1") as EXTREELib.Column).Width = 32;
(axTree1.Columns.Add("E2") as EXTREELib.Column).Width = 32;
(axTree1.Columns.Add("E3") as EXTREELib.Column).Width = 32;
(axTree1.Columns.Add("E4") as EXTREELib.Column).Width = 32;
|
|
467
|
Is there any option to show the tooltip programmatically
// MouseMove event - Occurs when the user moves the mouse.
private void axTree1_MouseMoveEvent(object sender, AxEXTREELib._ITreeEvents_MouseMoveEvent e)
{
axTree1.ShowToolTip(axTree1.get_ItemFromPoint(-1,-1,c,hit).ToString(),"","8","8",null);
}
//this.axTree1.MouseMoveEvent += new AxEXTREELib._ITreeEvents_MouseMoveEventHandler(this.axTree1_MouseMoveEvent);
axTree1.BeginUpdate();
axTree1.Columns.Add("Def");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
axTree1.EndUpdate();
|
|
466
|
Is it possible to prevent changing the rows/items colors by selection
axTree1.SelBackMode = EXTREELib.BackModeEnum.exTransparent;
(axTree1.Columns.Add("HTML") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.");
var_Items.set_SelectItem(var_Items.AddItem("<font ;6>This</font> <b>is</b> another <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>."),true);
|
|
465
|
Is it possible to specify the cell's value but still want to display some formatted text instead the value
axTree1.BeginUpdate();
axTree1.MarkSearchColumn = false;
axTree1.Columns.Add("Value");
axTree1.Columns.Add("FormatCell");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem(1);
var_Items.set_CellCaption(h,1,12);
var_Items.set_FormatCell(h,1,"currency(value)");
h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaptionFormat(h,1,EXTREELib.CaptionFormatEnum.exHTML);
var_Items.set_FormatCell(h,1,"longdate(value) replace '2001' with '<b>2001</b>'");
axTree1.EndUpdate();
|
|
464
|
How can I simulate displaying groups
axTree1.BeginUpdate();
axTree1.HasLines = EXTREELib.HierarchyLineEnum.exNoLine;
axTree1.ScrollBySingleLine = true;
axTree1.MarkSearchColumn = false;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Name");
var_Columns.Add("A");
var_Columns.Add("B");
var_Columns.Add("C");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Group 1");
var_Items.set_CellHAlignment(h,0,EXTREELib.AlignmentEnum.CenterAlignment);
var_Items.set_ItemDivider(h,0);
var_Items.set_ItemDividerLineAlignment(h,EXTREELib.DividerAlignmentEnum.DividerBoth);
var_Items.set_ItemHeight(h,24);
var_Items.set_SortableItem(h,false);
int h1 = var_Items.InsertItem(h,null,"Child 1");
var_Items.set_CellCaption(h1,1,1);
var_Items.set_CellCaption(h1,2,2);
var_Items.set_CellCaption(h1,3,3);
h1 = var_Items.InsertItem(h,null,"Child 2");
var_Items.set_CellCaption(h1,1,4);
var_Items.set_CellCaption(h1,2,5);
var_Items.set_CellCaption(h1,3,6);
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Group 2");
var_Items.set_CellHAlignment(h,0,EXTREELib.AlignmentEnum.CenterAlignment);
var_Items.set_ItemDivider(h,0);
var_Items.set_ItemDividerLineAlignment(h,EXTREELib.DividerAlignmentEnum.DividerBoth);
var_Items.set_ItemHeight(h,24);
var_Items.set_SortableItem(h,false);
h1 = var_Items.InsertItem(h,null,"Child 1");
var_Items.set_CellCaption(h1,1,1);
var_Items.set_CellCaption(h1,2,2);
var_Items.set_CellCaption(h1,3,3);
h1 = var_Items.InsertItem(h,null,"Child 2");
var_Items.set_CellCaption(h1,1,4);
var_Items.set_CellCaption(h1,2,5);
var_Items.set_CellCaption(h1,3,6);
var_Items.set_ExpandItem(h,true);
axTree1.EndUpdate();
|
|
463
|
How can I collapse all items
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Items");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(0,false);
axTree1.EndUpdate();
|
|
462
|
How can I expand all items
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Items");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(0,true);
axTree1.EndUpdate();
|
|
461
|
Can I use PNG images to display pictures in the control
axTree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\card.png");
axTree1.HeaderHeight = 48;
(axTree1.Columns.Add("ColumnName") as EXTREELib.Column).HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture";
|
|
460
|
Is it possible to move an item from a parent to another
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Items");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("A");
var_Items.AddItem("B");
var_Items.InsertItem(var_Items.AddItem("C"),"","D");
var_Items.SetParent(var_Items.get_FindItem("D",0,null),var_Items.get_FindItem("A",0,null));
axTree1.EndUpdate();
|
|
459
|
How can I change the identation for an item
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Items");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("A");
var_Items.AddItem("B");
var_Items.InsertItem(var_Items.AddItem("C"),"","D");
var_Items.SetParent(var_Items.get_FindItem("D",0,null),0);
axTree1.EndUpdate();
|
|
458
|
How can I filter programatically using more columns
axTree1.BeginUpdate();
axTree1.MarkSearchColumn = false;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Car");
var_Columns.Add("Equipment");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag");
var_Items.set_CellCaption(var_Items.AddItem("Toyota"),1,"Air Bag,Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Ford"),1,"Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Nissan"),1,"Air Bag,ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag, ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"ABS,ESP");
EXTREELib.Column var_Column = axTree1.Columns["Car"];
var_Column.FilterType = EXTREELib.FilterTypeEnum.exFilter;
var_Column.Filter = "Mazda";
EXTREELib.Column var_Column1 = axTree1.Columns["Equipment"];
var_Column1.FilterType = EXTREELib.FilterTypeEnum.exPattern;
var_Column1.Filter = "*ABS*|*ESP*";
axTree1.ApplyFilter();
axTree1.EndUpdate();
|
|
457
|
Is it possible to colour a particular column, I mean the cell's foreground color
axTree1.BeginUpdate();
EXTREELib.ConditionalFormat var_ConditionalFormat = axTree1.ConditionalFormats.Add("1",null);
var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
var_ConditionalFormat.ApplyTo = (EXTREELib.FormatApplyToEnum)0x1;
axTree1.MarkSearchColumn = false;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
axTree1.EndUpdate();
|
|
456
|
Is it possible to colour a particular column for specified values
axTree1.BeginUpdate();
EXTREELib.ConditionalFormat var_ConditionalFormat = axTree1.ConditionalFormats.Add("int(%1) in (3,4,5)",null);
var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
var_ConditionalFormat.ApplyTo = (EXTREELib.FormatApplyToEnum)0x1;
axTree1.MarkSearchColumn = false;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
axTree1.EndUpdate();
|
|
455
|
Is it possible to colour a particular column
axTree1.BeginUpdate();
axTree1.MarkSearchColumn = false;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Column 1");
(var_Columns.Add("Column 2") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exCellBackColor,255);
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
axTree1.EndUpdate();
|
|
454
|
How do i get all the children items that are under a certain parent Item handle
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("P");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
EXTREELib.Items var_Items1 = axTree1.Items;
int hChild = var_Items1.get_ItemChild(var_Items1.FirstVisibleItem);
System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(hChild,0).ToString() );
System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(var_Items1.get_NextSiblingItem(hChild),0).ToString() );
axTree1.EndUpdate();
|
|
453
|
How can I get the caption of focused item
// SelectionChanged event - Fired after a new item has been selected.
private void axTree1_SelectionChanged(object sender, EventArgs e)
{
EXTREELib.Items var_Items = axTree1.Items;
System.Diagnostics.Debug.Print( "Handle" );
System.Diagnostics.Debug.Print( var_Items.FocusItem.ToString() );
System.Diagnostics.Debug.Print( "Caption" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,0).ToString() );
}
//this.axTree1.SelectionChanged += new EventHandler(this.axTree1_SelectionChanged);
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Items");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("R1");
var_Items.InsertItem(h,null,"Cell 1.1");
var_Items.InsertItem(h,null,"Cell 1.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,null,"Cell 2.1");
var_Items.InsertItem(h,null,"Cell 2.2");
var_Items.set_ExpandItem(h,true);
axTree1.EndUpdate();
|
|
452
|
How can I get the caption of selected item
// SelectionChanged event - Fired after a new item has been selected.
private void axTree1_SelectionChanged(object sender, EventArgs e)
{
EXTREELib.Items var_Items = axTree1.Items;
System.Diagnostics.Debug.Print( "Handle" );
System.Diagnostics.Debug.Print( var_Items.get_SelectedItem(0).ToString() );
System.Diagnostics.Debug.Print( "Caption" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.get_SelectedItem(0),0).ToString() );
}
//this.axTree1.SelectionChanged += new EventHandler(this.axTree1_SelectionChanged);
axTree1.BeginUpdate();
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
axTree1.Columns.Add("Items");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("R1");
var_Items.InsertItem(h,null,"Cell 1.1");
var_Items.InsertItem(h,null,"Cell 1.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,null,"Cell 2.1");
var_Items.InsertItem(h,null,"Cell 2.2");
var_Items.set_ExpandItem(h,true);
axTree1.EndUpdate();
|
|
451
|
Can I display the cell's check box after the text
EXTREELib.Column var_Column = (axTree1.Columns.Add("Column") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,check");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 1"),0,true);
var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 2"),0,true);
|
|
450
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
axTree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(axTree1.Columns.Add("Column") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Text");
var_Items.set_CellImage(h,0,1);
var_Items.set_CellHasCheckBox(h,0,true);
|
|
449
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
axTree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(axTree1.Columns.Add("Column") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Text");
var_Items.set_CellImage(h,0,1);
|
|
448
|
Does your control support RightToLeft property for RTL languages or right to left
axTree1.BeginUpdate();
axTree1.ScrollBars = EXTREELib.ScrollBarsEnum.exDisableBoth;
axTree1.LinesAtRoot = EXTREELib.LinesAtRootEnum.exLinesAtRoot;
EXTREELib.Column var_Column = (axTree1.Columns.Add("P1") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.PartialCheck = true;
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
axTree1.RightToLeft = true;
axTree1.EndUpdate();
|
|
447
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
axTree1.BeginUpdate();
axTree1.ScrollBars = EXTREELib.ScrollBarsEnum.exDisableBoth;
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("C1");
var_Columns.Add("C2");
var_Columns.Add("C3");
var_Columns.Add("C4");
var_Columns.Add("C5");
var_Columns.Add("C6");
var_Columns.Add("C7");
var_Columns.Add("C8");
axTree1.RightToLeft = true;
axTree1.EndUpdate();
|
|
446
|
How can I use the CASE statement (CASE usage)
axTree1.BeginUpdate();
(axTree1.Columns.Add("Value") as EXTREELib.Column).Width = 24;
EXTREELib.Column var_Column = (axTree1.Columns.Add("CASE - statment") as EXTREELib.Column);
var_Column.ComputedField = "%0 case (default:'not found';1:%0;2:2*%0;3:3*%0;4:4*%0;5:5*%0;7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen';14:'Fourt" +
"heen')";
var_Column.ToolTip = var_Column.ComputedField;
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
axTree1.EndUpdate();
|
|
445
|
How can I use the CASE statement (CASE usage)
axTree1.BeginUpdate();
(axTree1.Columns.Add("Value") as EXTREELib.Column).Width = 24;
EXTREELib.Column var_Column = (axTree1.Columns.Add("CASE - statment") as EXTREELib.Column);
var_Column.ComputedField = "%0 case (default:'not found';1:'One';2:'Two';3:'Three';4:'Four';5:'Five';7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen" +
"';14:'Fourtheen')";
var_Column.ToolTip = var_Column.ComputedField;
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
axTree1.EndUpdate();
|
|
444
|
I have seen the IN function but it returns -1 or 0. How can I display the value being found ( SWITCH usage )
axTree1.BeginUpdate();
(axTree1.Columns.Add("Value") as EXTREELib.Column).Width = 24;
EXTREELib.Column var_Column = (axTree1.Columns.Add("SWITCH - statment") as EXTREELib.Column);
var_Column.ComputedField = "%0 switch ('not found', 1,2,3,4,5,7,8,9,11,13,14)";
var_Column.ToolTip = var_Column.ComputedField;
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
axTree1.EndUpdate();
|
|
443
|
I have a large collection of constant values and using or operator is a time consuming (IN usage). Is there any way to increase the speed to check if a value maches the collection
axTree1.BeginUpdate();
(axTree1.Columns.Add("Value") as EXTREELib.Column).Width = 24;
EXTREELib.Column var_Column = (axTree1.Columns.Add("IN - statment") as EXTREELib.Column);
var_Column.ComputedField = "%0 in (1,2,3,4,5,7,8,9,11,13,14) ? 'found' : ''";
var_Column.ToolTip = var_Column.ComputedField;
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(0);
var_Items.AddItem(1);
var_Items.AddItem(2);
axTree1.EndUpdate();
|
|
442
|
Is is possible to use HTML tags to display in the filter caption
axTree1.BeginUpdate();
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarCaption = "This is a bit of text being displayed in the filter bar.";
axTree1.Columns.Add("");
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
axTree1.EndUpdate();
|
|
441
|
How can I find the number of items after filtering
axTree1.BeginUpdate();
axTree1.Columns.Add("");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("");
var_Items.set_CellCaption(h,0,var_Items.VisibleItemCount);
axTree1.EndUpdate();
|
|
440
|
How can I change the filter caption
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptWords | EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
axTree1.FilterBarPromptPattern = "london robert";
axTree1.FilterBarCaption = "<r>Found: ... ";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
439
|
While using the filter prompt is it is possible to use wild characters
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptPattern;
axTree1.FilterBarPromptPattern = "lon* seat*";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
438
|
How can I list all items that contains any of specified words, not necessary at the beggining
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptStartWords | EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
axTree1.FilterBarPromptPattern = "london davolio";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
437
|
How can I list all items that contains any of specified words, not strings
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptWords | EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
axTree1.FilterBarPromptPattern = "london nancy";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
436
|
How can I list all items that contains all specified words, not strings
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptWords | EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
axTree1.FilterBarPromptPattern = "london robert";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
435
|
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptCaseSensitive | EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
axTree1.FilterBarPromptPattern = "Anne";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
434
|
Is it possible to list only items that ends with any of specified strings
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptEndWith;
axTree1.FilterBarPromptColumns = "0";
axTree1.FilterBarPromptPattern = "Fuller";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
433
|
Is it possible to list only items that ends with any of specified strings
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptEndWith;
axTree1.FilterBarPromptColumns = "0";
axTree1.FilterBarPromptPattern = "Fuller";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
432
|
Is it possible to list only items that starts with any of specified strings
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptStartWith;
axTree1.FilterBarPromptColumns = "0";
axTree1.FilterBarPromptPattern = "An M";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
431
|
Is it possible to list only items that starts with specified string
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptStartWith;
axTree1.FilterBarPromptColumns = "0";
axTree1.FilterBarPromptPattern = "A";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
430
|
How can I specify that the list should include any of the seqeunces in the pattern
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
axTree1.FilterBarPromptPattern = "london seattle";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
429
|
How can I specify that all sequences in the filter pattern must be included in the list
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptType = EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
axTree1.FilterBarPromptPattern = "london manager";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
428
|
How do I change at runtime the filter prompt
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptPattern = "london manager";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
427
|
How do I specify to filter only a single column when using the filter prompt
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPromptColumns = "2,3";
axTree1.FilterBarPromptPattern = "london";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
426
|
How do I change the prompt or the caption being displayed in the filter bar
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
axTree1.FilterBarPrompt = "changed";
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
axTree1.EndUpdate();
|
|
425
|
How do I enable the filter prompt feature
axTree1.BeginUpdate();
axTree1.ColumnAutoResize = true;
axTree1.ContinueColumnScroll = false;
axTree1.MarkSearchColumn = false;
axTree1.SearchColumnIndex = 1;
axTree1.FilterBarPromptVisible = true;
EXTREELib.Columns var_Columns = axTree1.Columns;
(var_Columns.Add("Name") as EXTREELib.Column).Width = 96;
(var_Columns.Add("Title") as EXTREELib.Column).Width = 96;
var_Columns.Add("City");
EXTREELib.Items var_Items = axTree1.Items;
int h0 = var_Items.AddItem("Nancy Davolio");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Andrew Fuller");
var_Items.set_CellCaption(h0,1,"Vice President, Sales");
var_Items.set_CellCaption(h0,2,"Tacoma");
var_Items.set_SelectItem(h0,true);
h0 = var_Items.AddItem("Janet Leverling");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Kirkland");
h0 = var_Items.AddItem("Margaret Peacock");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"Redmond");
h0 = var_Items.AddItem("Steven Buchanan");
var_Items.set_CellCaption(h0,1,"Sales Manager");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Michael Suyama");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Robert King");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
h0 = var_Items.AddItem("Laura Callahan");
var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
var_Items.set_CellCaption(h0,2,"Seattle");
h0 = var_Items.AddItem("Anne Dodsworth");
var_Items.set_CellCaption(h0,1,"Sales Representative");
var_Items.set_CellCaption(h0,2,"London");
axTree1.EndUpdate();
|
|
424
|
I have an EBN file how can I apply different colors to it, so no need to create a new one
axTree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
axTree1.SelBackColor = axTree1.BackColor;
axTree1.SelForeColor = axTree1.ForeColor;
axTree1.HasLines = EXTREELib.HierarchyLineEnum.exNoLine;
axTree1.Columns.Add("Default");
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
int hC = var_Items.InsertItem(h,null,"Default");
var_Items.set_ItemBackColor(hC,0x1000000);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Light Green");
var_Items.set_ItemBackColor(hC,0x100ff00);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Dark Green");
var_Items.set_ItemBackColor(hC,0x1007f00);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Magenta");
var_Items.set_ItemBackColor(hC,0x1ff7fff);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
hC = var_Items.InsertItem(h,null,"Yellow");
var_Items.set_ItemBackColor(hC,0x17fffff);
var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
var_Items.set_ExpandItem(h,true);
|
|
423
|
How can I change the foreground color for a particular column
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Column 1");
(var_Columns.Add("Column 2") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exHeaderForeColor,8439039);
var_Columns.Add("Column 3");
|
|
422
|
How can I change the background color for a particular column
EXTREELib.Columns var_Columns = axTree1.Columns;
var_Columns.Add("Column 1");
(var_Columns.Add("Column 2") as EXTREELib.Column).set_Def(EXTREELib.DefColumnEnum.exHeaderBackColor,8439039);
var_Columns.Add("Column 3");
|
|
421
|
How can I display the column using currency format and enlarge the font for certain values
EXTREELib.Column var_Column = (axTree1.Columns.Add("Currency") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("9.94");
var_Items.AddItem("11.94");
var_Items.AddItem("1000");
|
|
420
|
How can I highlight only parts of the cells
EXTREELib.Column var_Column = (axTree1.Columns.Add("") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
419
|
How can I get the number of occurrences of a specified string in the cell
axTree1.Columns.Add("");
EXTREELib.Column var_Column = (axTree1.Columns.Add("occurrences") as EXTREELib.Column);
var_Column.ComputedField = "lower(%0) count 'o'";
var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1 oooof the root");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
418
|
How can I display dates in my format
EXTREELib.Column var_Column = (axTree1.Columns.Add("Date") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/21/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/24/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
417
|
How can I display dates in short format
(axTree1.Columns.Add("Date") as EXTREELib.Column).FormatColumn = "shortdate(value)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
416
|
How can I display dates in long format
(axTree1.Columns.Add("Date") as EXTREELib.Column).FormatColumn = "longdate(value)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
415
|
How can I display only the right part of the cell
axTree1.Columns.Add("");
EXTREELib.Column var_Column = (axTree1.Columns.Add("Right") as EXTREELib.Column);
var_Column.ComputedField = "%0 right 2";
var_Column.FormatColumn = "'\"' + value + '\"'";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
414
|
How can I display only the left part of the cell
axTree1.Columns.Add("");
(axTree1.Columns.Add("Left") as EXTREELib.Column).ComputedField = "%0 left 2";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
413
|
How can I display true or false instead 0 and -1
(axTree1.Columns.Add("Boolean") as EXTREELib.Column).FormatColumn = "value != 0 ? 'true' : 'false'";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(true);
var_Items.AddItem(false);
var_Items.AddItem(true);
var_Items.AddItem(0);
var_Items.AddItem(1);
|
|
412
|
How can I display icons or images instead numbers
axTree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXTREELib.Column var_Column = (axTree1.Columns.Add("Icons") as EXTREELib.Column);
var_Column.set_Def(EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(1);
var_Items.AddItem(2);
var_Items.AddItem(3);
|
|
411
|
How can I display the column using currency
(axTree1.Columns.Add("Currency") as EXTREELib.Column).FormatColumn = "currency(dbl(value))";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.AddItem(5);
var_Items.AddItem("10000.99");
|
|
410
|
How can I display the currency only for not empty cells
axTree1.Columns.Add("Number");
(axTree1.Columns.Add("Currency") as EXTREELib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.set_ItemBackColor(var_Items.AddItem(null),(uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)));
var_Items.AddItem("10000.99");
|
|
409
|
Is there a function to display the number of days between two date including the number of hours
(axTree1.Columns.Add("Start") as EXTREELib.Column).Width = 32;
axTree1.Columns.Add("End");
(axTree1.Columns.Add("Duration") as EXTREELib.Column).ComputedField = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : " +
"'') + =:3 + ' hour(s)' : '' )";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
408
|
Is there a function to display the number of days between two date including the number of hours
axTree1.Columns.Add("Start");
axTree1.Columns.Add("End");
(axTree1.Columns.Add("Duration") as EXTREELib.Column).ComputedField = "\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001 23:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
407
|
How can I display the number of days between two dates
axTree1.Columns.Add("Start");
axTree1.Columns.Add("End");
(axTree1.Columns.Add("Duration") as EXTREELib.Column).ComputedField = "(date(%1)-date(%0)) + ' days'";
EXTREELib.Items var_Items = axTree1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
406
|
How can I get second part of the date
axTree1.Columns.Add("Date");
(axTree1.Columns.Add("Second") as EXTREELib.Column).ComputedField = "sec(date(%0))";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:22",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:01",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:59",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
405
|
How can I get minute part of the date
axTree1.Columns.Add("Date");
(axTree1.Columns.Add("Minute") as EXTREELib.Column).ComputedField = "min(date(%0))";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
404
|
How can I check the hour part only so I know it was afternoon
axTree1.ConditionalFormats.Add("hour(%0)>=12",null).Bold = true;
axTree1.Columns.Add("Date");
(axTree1.Columns.Add("Hour") as EXTREELib.Column).ComputedField = "hour(%0)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
403
|
What about a function to get the day in the week, or days since Sunday
axTree1.Columns.Add("Date");
(axTree1.Columns.Add("WeekDay") as EXTREELib.Column).ComputedField = "weekday(%0)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
402
|
Is there any function to get the day of the year or number of days since January 1st
axTree1.Columns.Add("Date");
(axTree1.Columns.Add("Day since January 1st") as EXTREELib.Column).ComputedField = "yearday(%0)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
401
|
How can I display only the day of the date
axTree1.Columns.Add("Date");
(axTree1.Columns.Add("Day") as EXTREELib.Column).ComputedField = "day(%0)";
EXTREELib.Items var_Items = axTree1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|